Welcome to this video on Assignment Overview: Data Visualization Using Excel. After watching this video, you will be able to: Identify the main objective of the assignment List the visualizations to analyze the trends and insights from the customer and transaction data. This assignment will guide you through creating data visualizations to help FinPro Bank analyze key trends and insights from its customer and transaction data. Using Excel's powerful visualization tools, you'll create a series of charts and graphs that enable bank management to quickly identify transaction trends, customer demographics, high-performing branches, and areas of potential risk. These visualizations will serve as the foundation for further analysis and reporting in subsequent steps, such as business intelligence and decision-making processes. This exercise focuses on developing both technical skills in Excel visualization and analytical skills to interpret financial data effectively. You'll be tasked with using data from the customer, account, transaction, branch, and countries tables to answer critical business questions, like identifying the top-performing branches, high-value customers, and seasonal transaction trends. In this assignment, you will first inspect the cleaned and transformed data from the previous lesson. Identify primary keys, foreign keys, and the interrelations among tables to grasp how they can be interconnected in pivot table analyses. In the second step, you will use Excel's charting tools to create the following visualizations based on the data tables provided. Each chart should be clear, labeled, and easily interpretable for stakeholders at FinPro Bank. Customer Age Distribution: Calculate the age of each customer using their date of birth. Group customers by age ranges, for example, 18-25, 26-35, 36-50, 51+, in a new column called Age Group. Create a histogram, or bar chart, showing the number of customers in each age range. Balance Distribution by Account Type: Use a stacked column chart to display the balance distribution across different account types, savings versus checking. Ensure you enter negative and non-numeric balances by filtering or categorizing these entries accordingly. Country Representation: Use a pie chart to show the percentage of customers from different countries. This chart can help visualize the location of the majority of FinPro Bank's customers. Also, visualize the following: Monthly Transaction Volume: Extract the month and year from the Transaction Date column to create a Transaction Month Year field. Use a line chart to show transaction volume over time, highlighting any seasonal spikes or troughs. Transaction Type Breakdown: Use a pie chart or donut chart to display the proportion of different transaction types, for example, deposits versus withdrawals. This chart will help stakeholders understand the nature of customer interactions with the bank. Average Transaction Amount by Month: Calculate the average monthly transaction amount by aggregating transaction amount over each month. Use a column chart to display average monthly transaction amounts, providing insight into transaction value trends. The rest of the visualizations are: High Value Transactions Heatmap: Filter transactions to show only those above a certain high value threshold, for example, $500, and sort by branch. Create a heatmap using conditional formatting to highlight branches with frequent high value transactions, aiding fraud detection and risk management. Compile Key Metrics: Create a summary sheet that displays key metrics for stakeholders, such as: total customers, total monthly transactions, branch with the highest average transaction value, and most common transaction type. In this video, you learned that, in this assignment: You will use Excel's charting tools to create a series of charts and graphs that enable bank management to quickly identify transaction trends, customer demographics, high-performing branches, and areas of potential risk. You'll be tasked with using data from the Customer, Account, Transaction, Branch, and Countries tables to answer critical business questions, like identifying the top performing branches, high-value customers, and seasonal transaction trends.